use SSISReportingPack
DECLARE @vETLJobName		NVARCHAR(MAX)	=	'MyETLJob';
DECLARE @vETLJobStageName1	NVARCHAR(MAX)	=	'LoadProductDimension';
DECLARE @vETLJobStageName2	NVARCHAR(MAX)	=	'LoadCustomerDimension';
DECLARE @vETLJobStageName3	NVARCHAR(MAX)	=	'LoadSalesFact';
DECLARE	@vETLJobId			SMALLINT;
DECLARE	@vETLJobStageId1	SMALLINT;
DECLARE	@vETLJobStageId2	SMALLINT;
DECLARE	@vETLJobStageId3	SMALLINT;
EXEC	[RestartFramework].[PutETLJob] @pETLJobName = @vETLJobName, @pETLJobId = @vETLJobId OUTPUT;

EXEC	[RestartFramework].[PutETLJobStage] @pETLJobId = @vETLJobId,@pETLJobStageName = @vETLJobStageName1, @pETLJobStageOrder=10,@pETLJobStageId=@vETLJobStageId1	OUTPUT;
EXEC	[RestartFramework].[PutETLJobStage] @pETLJobId = @vETLJobId,@pETLJobStageName = @vETLJobStageName2, @pETLJobStageOrder=10,@pETLJobStageId=@vETLJobStageId2	OUTPUT;
EXEC	[RestartFramework].[PutETLJobStage] @pETLJobId = @vETLJobId,@pETLJobStageName = @vETLJobStageName3, @pETLJobStageOrder=20,@pETLJobStageId=@vETLJobStageId3	OUTPUT;
--SELECT	vETLJobId=@vETLJobId,vETLJobStageId1=@vETLJobStageId1,vETLJobStageId2=@vETLJobStageId2,vETLJobStageId3=@vETLJobStageId3

SELECT	*
FROM	[RestartFramework].[GetETLJobStagesPerETLJobNameETLJobStageOrder](@vETLJobName,DEFAULT,DEFAULT)

